select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Pink Ball Gown Quinceanera Dresses with Appliques and Ruffles
Ball Gown Beaded Black and Blue Feather Quinceanera Dresses
Cheap Spring Green Dress for Sweet 16 with Embroidery Online
Venice Film Festival Zebra Print Ruffled Colorful Quinces Dress with Spaghetti Straps
Pretty Taffeta Pick-ups Appliqued Dress for Sweet 16
Sweetheart Colorful Ruffled Beaded Sweet 15/16 Birthday Dress
Custom Made Appliqued Hot Pink and Black Quinceanera Dresses
Low Price Appliqued Purple Dress for Sweet 16 with Pick-ups
Corset Ruffled Appliqued Multi-color Sweet Sixteen Dresses Shop
Beaded Ruffled Hot Pink Dresses for Sweet 16 with Corset Back
Wholesale Yellow Green and White Quince Dress with Embroidery
Long Sleeves Appliqued Purple Dresses for Sweet 15 for Rent
Pretty Baby Blue Appliqued Beaded Quinceanera Gown Dresses
Low Price Apple Green Sweet 16 Dresses with Colorful Flowers
Two-toned Sequins Beaded Tiered Sweet Sixteen Dresses Online
Strapless Purple Quinceanera Dresses with Embroidery for Rent
Yellow Green Ball Gown Sweet 16 Dress with Beading about 200
Cheap Organza Sweetheart Beaded White Dresses for a Quince
Taffeta Pick-ups Embroidery Green Quinceanera Gown Dresses
Pretty Taffeta Organza Embroidery Olive Green Quinces Dress
Ball Gown Sweetheart Purple Dresses for a Quinceanera 2012
Ball Gown Strapless Ruched Beaded Lavender Quinces Dresses
Ball Gown Strapless Appliqued Champagne Quinceanera Dresses
Ball Gown Sweetheart Appliqued Blue Quinceanera Gown Dresses
Slot Neck Ball Gown Floor-Length Fuchsia Quinceanera Dresses
Cute Pink Strapless Appliqued Ball Gown Lace Hem Quince Dresses
Orange Ball Gown Beading Ruched Quince Dresses with Ruffles Plus
Beading Purple one Shoulder Appliqued Ball Gown Quince Dresses
Purple Ball Gown Pick-ups Embroidery Quince Dresses with Straps
Light Green Ball Gown Embroidery Pick-ups Dresses Quinceanera